//
//  TabelJurisdiction.m
//  NursingManages
//
//  Created by Zhen Huang on 17/5/27.
//  Copyright © 2017年 huangzhen. All rights reserved.
//

#import "TabelJurisdiction.h"
#import "DBHelper.h"
#import "Model_Hr_Atd_Scd_Group.h"
@implementation TabelJurisdiction


//查询数据 相当于数据读取操作
- (NSMutableArray *)Jurisdiction {
    [DBHelper.DB open];
    FMResultSet *set = [DBHelper.DB executeQuery:@"select group_name,group_id,input_code1 from hr_atd_scd_group"];
    NSMutableArray *array = [NSMutableArray array];
    while ([set next]) {
        Model_Hr_Atd_Scd_Group *model = [[Model_Hr_Atd_Scd_Group alloc]init];
        model.GROUP_NAME = [set stringForColumn:@"group_name"];
        model.GROUP_ID = [set stringForColumn:@"group_id"];
        model.INPUT_CODE1=[set stringForColumn:@"input_code1"];
        [array addObject:model];
    }
    [DBHelper.DB close];
    return array;
}

@end
